/* for valgrind across calls semantic checking.  */

!ls
create table soaps(soapid  i, sname  c28, network  c4, rating  f);
create table stars(starid  i, stname  c20, plays  c12, soapid  i);

/* load tuples from ./tests/stars.data */
load soaps("../soaps.data");

/* build some indices on stars */
create index stars(starid);
create index stars(stname);

/* load tuples from ./tests/stars.data */
load stars("../stars.data");

delete from stars where soapid > 4;

update soaps set network = "HBO" where soapid = 3;

insert into soaps values(133, "The Good Wife", "CBS", 4.0);

exit;
